CREATE TABLE [dbo].[FS_Notice]
(
[fdID] [int] NOT NULL IDENTITY(1, 1),
[fdCollID] [int] NULL,
[fdName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdContent] [text] COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdAt] [datetime] NOT NULL CONSTRAINT [DF_FS_Notice_fdAt] DEFAULT (getdate()),
[fdLevel] [int] NOT NULL CONSTRAINT [DF_FS_Notice_fdLevel] DEFAULT ((3)),
[fdYear] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[FS_Notice] ADD CONSTRAINT [PK_FS_Notice] PRIMARY KEY CLUSTERED  ([fdID]) ON [PRIMARY]
GO
